Spread Silverlight Documentation
Evaluate(Object[]) Method


The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

Row_num is the row number to use in the cell reference.

Column_num is the column number to use in the cell reference.

[Abs_num] specifies the type of reference to return

[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

Creates a cell address as text, given specified row and column numbers.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcAddressFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

Row_num is the row number to use in the cell reference.

Column_num is the column number to use in the cell reference.

[Abs_num] specifies the type of reference to return

[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

Return Value

A System.Object value that indicates the evaluate result.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

CalcAddressFunction Class
CalcAddressFunction Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.